Excel 2016 : Creating Tours with 3D Maps
Excel 2016 : Creating Tours with 3D Maps
- Creating a map tour
- Managing tours
- Discovering 3D maps
- Creating a scene
- Customizing scenes
- Inserting data into a scene
- Managing scenes
- Presenting a tour
- Sharing tours
3D Maps for Excel 2016 is a 3D data visualization tool that's great for geographically or spatially mapping your data. Find out how to open the 3D Maps tool, and how to start building visual tours to explore and analyze your data.
Excel 2016: Configuring Options & Settings
Excel 2016: Configuring Options & Settings
- Managing your account & connected services
- Installing & managing add-ins
- Configuring your input options
- Configuring your default formula options
- Customizing your document default settings
- Customizing your interface
- Customizing the Quick Access toolbar
- Customizing the ribbon
Get more out of Excel 2016 by customizing it to your own needs. Learn how to manage your account, connected services, and add-ins; configure input and formula options; and customize the interface, ribbon, and Quick Access Toolbar.
Excel 2016: Creating Charts & Graphics
Excel 2016: Creating Charts & Graphics
- Inserting a chart
- Labeling a chart
- Formatting a chart
- Customizing your charts
- Customizing your chart axes
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Combining two types of chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trendlines
Analyze and present your data in a visually attractive manner in Excel 2016. Learn how to insert and customize charts, create chart templates, work with different chart types, and use trendlines.
Excel 2016: Creating PivotTables & PivotCharts
Excel 2016: Creating PivotTables & PivotCharts
- Creating a PivotTable
- Creating a PivotTable with multiple data tables
- Editing your PivotTable
- Formatting your PivotTable
- Copying & reusing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting data in your PivotTable
- Filtering your table data
- Grouping data in your PivotTable
- Inserting a slicer in your PivotTable
- Customizing your slicer
- Comparing values in a PivotTable
- Inserting a PivotChart
- Modifying your PivotChart
- Analyzing your database tables in a PivotChart
Excel 2016 includes powerful tools to summarize, sort, count, and chart data. Learn how to create, edit, and format PivotTables and PivotCharts; use calculations; sort, filter, and group data; and work with a slicer.
Excel 2016: Creating, Saving & Sharing Workbooks
Excel 2016: Creating, Saving & Sharing Workbooks
- Creating & opening a document
- Using document templates
- Managing your worksheets
- Saving your document
- Saving your document as a PDF
- Returning to a previous version of your document
- Inserting headers & footers
- Setting your print area
- Adjusting your print page layout
- Printing your document
- Checking for compatibility issues
- Editing your document properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
- Sending your document via email
- Sharing your document via OneDrive
- Commenting on a document
- Following & tracking document changes
Excel 2016 is highly customizable and easy to share with others. Learn how to create, manage, and save documents; insert headers and footers; edit document properties; and protect and share your workbooks.
Excel 2016: Custom & Conditional Formatting
Excel 2016: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing your date & time formats
- Creating conditional custom formats
- Using the conditional formatting tools
- Using advanced conditional formatting
- Applying color to the first new entry in a list
To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.
Excel 2016: Custom & Conditional Formatting
Excel 2016: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing your date & time formats
- Creating conditional custom formats
- Using the conditional formatting tools
- Using advanced conditional formatting
- Applying color to the first new entry in a list
To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.
Excel 2016: Extracting Information with Formulas
Excel 2016: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data values in a single cell
- Retrieving information on a cell
- Retrieving information on your text
- Cross referencing two data lists
- Inserting data automatically
- Finding a value in a double entry table
- Performing a search across two tables
- Finding data in a database
- Performing calculations using your database
Excel 2016 has a number of formulas for extracting both numeric and textual data from cells. Discover how to use some of these formulas, including MONTH, DAY, YEAR, MAX, MIN, CONCATENATE, SEARCH, LEN, LOOKUP, and VLOOKUP.
Excel 2016: Finding, Sorting & Filtering Data
Excel 2016: Finding, Sorting & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting your data
- Filtering your data
- Sorting & filtering using colors
- Using slicers in tables
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping items & creating an outline
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.
Excel 2016: Finding, Sorting & Filtering Data
Excel 2016: Finding, Sorting & Filtering Data
- Using the Find tool
- Using the Replace tool
- Using the Find & Replace tools in a formula
- Sorting your data
- Filtering your data
- Sorting & filtering using colors
- Using slicers in tables
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping items & creating an outline
Excel 2016 includes a number of methods for locating and displaying only certain entries. Learn how to work with specific data using the Find and Replace tools, sorting and filtering, hiding duplicates, and grouping.
Excel 2016: Formatting Data
Excel 2016: Formatting Data
- Setting your data type
- Formatting your data
- Aligning your data
- Using colors
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Formatting a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows
- Inserting borders
- Transferring format styles
Formatting data makes it easier to see and work with. Discover how you can align data, use colors and themes, resize rows and columns, and insert tables and borders in Excel 2016 to change data presentation.
Excel 2016: Getting Started
Excel 2016: Getting Started
- Finding & opening the application
- Exploring the Interface
- Using the zoom function
- Using the view modes
- Moving between documents
Excel 2016 is the spreadsheet application in the Microsoft Office 2016 suite. Explore the interface and some of its features, including the ribbon, status bar, zoom, and various view modes.
Excel 2016: Illustrating Documents
Excel 2016: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting shapes
- Inserting a hyperlink
- Using Smart Lookup
An Excel 2016 worksheet can contain more than just numbers and text. Discover how to insert and edit images, screenshots, and shapes; insert hyperlinks; and use the new Smart Lookup feature.
Excel 2016: Inserting & Manipulating Data
Excel 2016: Inserting & Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill feature
- Inserting dropdown menus
- Using the Spell Check tool
- Configuring Spell Check & AutoCorrect options
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.
Excel 2016: Inserting & Manipulating Data
Excel 2016: Inserting & Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill feature
- Inserting dropdown menus
- Using the Spell Check tool
- Configuring Spell Check & AutoCorrect options
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
Excel 2016 contains a number of features to aid in data insertion and manipulation. Explore numerous ways to insert, edit, and manipulate your data, including undo and redo, Flash Fill, spell check, and transposing a data range.
Excel 2016: Referencing Data
Excel 2016: Referencing Data
- Referencing your cells
- Using data across multiple worksheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constant values
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.
Excel 2016: Referencing Data
Excel 2016: Referencing Data
- Referencing your cells
- Using data across multiple worksheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constant values
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Many times, you will use a cell value in a formula or another location. Discover absolute and relative cell references, using data across multiple worksheets, formula auditing, and interpreting formula errors in Excel 2016.
Excel 2016: Using Conditional Formulas
Excel 2016: Using Conditional Formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Performing complex conditional formulas
- Creating multiple conditions
- Using IF & OR in conditional formulas
- Using conditional formulas to count up value occurrences
- Translating data in your worksheet
- Using reference positions in conditional formulas
- Keeping your table up to date with conditional formulas
In some cases, you may need to create formulas using data based on specific criteria in your range. Learn how to create and work with conditional formulas in Excel 2016, including SUMIF, SUMIFS, and SUMPRODUCT.
Excel 2016: Using Excel 2016 with Office 365
Excel 2016: Using Excel 2016 with Office 365
- Creating & opening a document
- Saving your document
- Inserting icons
- Configuring the default layout of PivotTables
- Annotating your workbook
- Sharing your workbook via e-mail
- Sharing your workbook via a link
- Managing link access & permissions
- Collaborating on an Excel workbook
- Managing a workbook's version history
If you or your organization has a qualifying Office 365 subscription, you can use it to install Excel 2016 and get the latest software updates released by Microsoft. Recent updates available to Office 365 subscribers using Excel 2016 include streamlined document management, annotation, and share interfaces, additional PivotTable configuration tools, and icon insertion capabilities.
Excel 2016: Using the Power Pivot Add-in
Excel 2016: Using the Power Pivot Add-in
- Activating Power Pivot
- Using the view settings in Power Pivot
- Importing your database
- Creating Power Pivot relationships
- Customizing your Power Pivot tables
- Applying data formats in Power Pivot tables
- Sorting the data in your Power Pivot table
- Filtering data in your Power Pivot table
- Creating a calculated field in your Power Pivot table
- Creating custom views in your Power Pivot table
- Updating your Power Pivot tables
- Creating an advanced PivotTable
- Creating an advanced PivotChart
- Creating a dashboard
You can create advanced PivotTables and analyze data from a variety of different sources using the Power Pivot add-in for Excel 2016. Learn how to use Power Pivot to import databases, create and modify tables, and create a dashboard.
Excel 2016: Using the Power View Add-in
Excel 2016: Using the Power View Add-in
- Activating Power View
- Creating a new report
- Managing your report tables
- Grouping data with tiles
- Creating relationships between tables
- Illustrating your Power View report
- Formatting your Power View report
- Organizing your Power View report
- Filtering the data in your report
- Using the advanced filter options in your Power View report
- Reusing a table
- Using a Matrix Table to visualize your data
- Using bar & column charts to visualize your data
- Using line charts to visualize your data
- Using scatter charts to visualize your data
- Using pie charts to visualize your data
- Visualizing your data in map form
You can use the Power View add-in to create reports in Excel 2016. Discover the capabilities of Power View, including illustrating and organizing reports, filtering data, and adding PivotTables and charts to reports.
Excel 2016: Working with Data in 3D Maps
Excel 2016: Working with Data in 3D Maps
- Working with layers
- Managing layers
- Adding data to a map
- Adding timestamps
- Adding data from multiple tables
- Using charts
- Customizing charts
- Using filters
- Using legends
- Customizing map data
- Managing the map display
Knowing how to bring in data and map it to your 3D Maps tours is key to getting the most out of your data. Learn how to use data from multiple tables, add layers, timestamps, and filters to better understand your tours, and how to customize the information on display.
Excel 2016: Working with Formulas
Excel 2016: Working with Formulas
- Calculating the interest on a loan
- Simulating a loan
- Reaching a target value
- Solving a problem
- Using the forecast tool
- Creating automatic reports
- Finding identical values in your spreadsheet
- Finding duplicates in your document
- Visualizing your duplicate values
- Preventing duplicate values
In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.
Microsoft Excel 2016 for Mac: Manipulating Data
Microsoft Excel 2016 for Mac: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill tool
- Inserting dropdown menus
- Using the spell check tool
- Configuring spell check & AutoCorrect options
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
It's possible to manually edit data in Excel; however, this can become tedious, especially with a lot of data. Work smarter, not harder, by exploring various methods for efficiently and effectively inserting and manipulating data in Excel.